Build Log Database

FastStats Designer can output progress log messages and build statistics to a build log database. The FastStats Configurator tool contains a database script to create this database. The database can be hosted on SQL Server, or any other standard relational database that supports standard SQL.

The connection to the build log database can be specified on the Build Tab:

Each of the build log database tables contains a tag column that can be populated by the tag parameter specified on the dialog. This can be specified with an environment variable.

 

Build Log Database Definition

The build log database consists of the following tables:

 

LogTable

Field Name	Data Type	Notes
Id	int
MessageName	datetime	Build machine time
Severity	char(5)	INFO/WARN/ERROR/FATAL
Message	nvarchar(max)
Tag	nvarchar(255)

Cardinality: One row per log message

 

BuildStatistics

Field Name	Data Type	Notes
SystemName	nvarchar(2000)
Tag	nvarchar(255)
BuildStart	datetime	Build machine time
ExtractFinish	datetime	Build machine time
AutoDiscoveryFinish	datetime	Build machine time
SortFinish	datetime	Build machine time
LoadFinish	datetime	Build machine time
PostLoadActionsFinish	datetime	Build machine time
BaseSystemSize	bigint	Bytes
VirtualSystemSize	bigint	Bytes

Cardinality: One row per build

 

BuildStatisticsDetails

Field Name	Data Type	Notes
SystemName	nvarchar(2000)
Tag	nvarchar(255)
BuildStart	datetime
TableName	varchar(2000)
Records	bigint
Orphans	bigint
Extract	float	Time taken: 1.0 = 24 hours
AutoDiscovery	float	Time taken: 1.0 = 24 hours
Sort	float	Time taken: 1.0 = 24 hours
Build	float	Time taken: 1.0 = 24 hours
FileSize	bigint	Bytes

Cardinality: One row per table per build